﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Model;
namespace DAL
{
  public  class DAL_RoomType_Tables
    {
      public static DataTable CXZuoZi(Model_Tables t)
      {
          string sql = "select * from Tables where RTID=@RTID and  tablestate like'%'+@tablestate+'%'";
          List<SqlParameter> list = new List<SqlParameter>{
            new SqlParameter("@RTID",t.RTID),
            new SqlParameter("@tablestate",t.TableState.ToString())
          };
          return DBHelper.Dataset(sql, list);
      }
    }
}
